
. * SEC 4.1
. * "95% of beneficiaries were married"
. tab benefmar,m

  Indicator |
  for woman |
      benef |
    married |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |         40        3.96        3.96
          1 |        964       95.35       99.31
          . |          7        0.69      100.00
------------+-----------------------------------
      Total |      1,011      100.00

. * FN 11
. * "In 90 percent of households, the beneficiary's husband is identified as the head. Otherwise, she is the head 
> (5 percent) or daughter of the head (4 percent)."
. tab relation,m

relation_be |
        nef |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         48        4.75        4.75
          2 |        906       89.61       94.36
          3 |         40        3.96       98.32
          4 |          4        0.40       98.71
          6 |          2        0.20       98.91
          7 |          2        0.20       99.11
          8 |          1        0.10       99.21
          9 |          1        0.10       99.31
          . |          7        0.69      100.00
------------+-----------------------------------
      Total |      1,011      100.00

. qui log close
{smcl}
{com}{sf}{ul off}{txt}
{com}. * SEC 5.1 
. *"There is slightly lower take-up in the fourth wave of the program; take-up for waves 1-4 was respectively 4 out of 126, 2 out of 113, 5 out of 122, and 10 out of 120." 
. tab hhtakeup follow if treatment==1, col
{txt}
{c TLC}{hline 19}{c TRC}
{c |} Key{col 21}{c |}
{c LT}{hline 19}{c RT}
{c |}{space 5}{it:frequency}{col 21}{c |}
{c |}{space 1}{it:column percentage}{col 21}{c |}
{c BLC}{hline 19}{c BRC}

   1 if hh {c |}
participat {c |}
 ed in the {c |}          number of follow-up round
   program {c |}         1          2          3          4 {c |}     Total
{hline 11}{c +}{hline 44}{c +}{hline 10}
         0 {c |}{res}         4          2          5         10 {txt}{c |}{res}        21 
           {txt}{c |}{res}      3.17       1.77       4.10       8.33 {txt}{c |}{res}      4.37 
{txt}{hline 11}{c +}{hline 44}{c +}{hline 10}
         1 {c |}{res}       122        111        117        110 {txt}{c |}{res}       460 
           {txt}{c |}{res}     96.83      98.23      95.90      91.67 {txt}{c |}{res}     95.63 
{txt}{hline 11}{c +}{hline 44}{c +}{hline 10}
     Total {c |}{res}       126        113        122        120 {txt}{c |}{res}       481 
           {txt}{c |}{res}    100.00     100.00     100.00     100.00 {txt}{c |}{res}    100.00 
{txt}
{com}. qui log close 
{smcl}
{com}{sf}{ul off}{smcl}
{com}{sf}{ul off}{txt}
{com}. * SEC 5.1
. * 68 percent of delegations were to a woman
. tab delegated_woman if delegated==1 & treatment==1 & delegated_man~=.

       {txt}1 if {c |}
  delegated {c |}
     public {c |}
 works to a {c |}
      woman {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}         44       41.90       41.90
{txt}          1 {c |}{res}         61       58.10      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}        105      100.00
{txt}
{com}. qui log close
{smcl}
{com}{sf}{ul off}{smcl}
{com}{sf}{ul off}{txt}
{com}. * SEC 5.1 
. *"Among the women who delegated the offer, just over a quarter delegate due to ineligibility imposed by the program on women who are pregnant or have very young infants (0-40 days old);  
. *15 percent of the women who delegate their participation in the program declare to have been sick at the time they received the job offer. 
. *Among the few remaining cases of delegation, caring for another household member is the main reason for not accepting the job offer (32 percent due to childcare constraints and 11 percent were related to the caring for a sick household member). 
. *Another 15 percent of delegations have no specific reason reported." 
. des deleg_re*

{txt}Variable      Storage   Display    Value
    name         type    format    label      Variable label
{hline}
{p 0 48}{res}{bind:deleg_reas_ma~y}{txt}{bind: float   }{bind:%9.0g     }{space 1}{bind:         }{bind:  }{res}{res}Deleg reason: mandatory{p_end}
{p 0 48}{bind:deleg_reas_ch~e}{txt}{bind: float   }{bind:%9.0g     }{space 1}{bind:         }{bind:  }{res}{res}1 if delageted bc had to care children (above 40 days){p_end}
{p 0 48}{bind:deleg_reas_wo~l}{txt}{bind: float   }{bind:%9.0g     }{space 1}{bind:         }{bind:  }{res}{res}1 if delegated bc she was ill{p_end}
{p 0 48}{bind:deleg_reas_ot~l}{txt}{bind: float   }{bind:%9.0g     }{space 1}{bind:         }{bind:  }{res}{res}1 if delegated bc other HH member was ill{p_end}
{p 0 48}{bind:deleg_reas_ot~r}{txt}{bind: float   }{bind:%9.0g     }{space 1}{bind:         }{bind:  }{res}{res}1 if delegated bc of other reason{p_end}
{txt}
{com}. sum deleg_reas_mandatory  deleg_reas_childcare    deleg_reas_woill    deleg_reas_otherill    deleg_reas_other 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
deleg_reas~y {c |}{res}         54    .2777778     .452109          0          1
{txt}deleg_reas~e {c |}{res}         54    .3148148    .4688031          0          1
{txt}deleg_r~oill {c |}{res}         54    .1481481    .3585825          0          1
{txt}deleg_r~rill {c |}{res}         54    .1111111    .3172206          0          1
{txt}deleg_reas~r {c |}{res}         54    .1481481    .3585825          0          1
{txt}
{com}. qui log close
{smcl}
{com}{sf}{ul off}{smcl}
{com}{sf}{ul off}{txt}
{com}. * SEC 4.2 
. * "Seventy three percent of the households are drawn from the bottom two quintiles of an asset index in urban Djibouti (based on the EDAM 2017)."
. sum bottom2q 

{txt}    Variable {c |}        Obs        Mean    Std. dev.       Min        Max
{hline 13}{c +}{hline 57}
{space 4}bottom2q {c |}{res}        997    .7331996    .4425092          0          1
{txt}
{com}. qui log close
{smcl}
{com}{sf}{ul off}{smcl}
{com}{sf}{ul off}{txt}
{com}. * SEC 5.1 
. * "We do notice that the extent of own participation (as opposed to delegation) decreases with higher wealth as measured by an asset index"
. tab quint_pmtedam_urban  if treatment ==1       , sum(delegated)        

        {txt}PMT {c |}
  quintiles {c |}
  from EDAM {c |}
   survey - {c |}   Summary of 1 if woman delegated
      urban {c |}            public works
     sample {c |}        Mean   Std. dev.       Freq.
{hline 12}{c +}{hline 36}
          1 {c |}  {res} .15789474   .36571318         171
  {txt}        2 {c |}  {res} .19889503   .40027615         181
  {txt}        3 {c |}  {res} .32954545   .47274184          88
  {txt}       45 {c |}  {res} .32352941   .47485808          34
{txt}{hline 12}{c +}{hline 36}
      Total {c |}  {res} .21729958   .41284386         474
{txt}
{com}. qui log close
{smcl}
{com}{sf}{ul off}{smcl}
{com}{sf}{ul off}{txt}
{com}. * SEC 3
. * At midline, most (93%) of women in the control households (all of whom would get the offer in the future) did know of the program.
. tab know if treatment==0

  {txt}1 if have {c |}
heard about {c |}
the program {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
          0 {c |}{res}         31        6.68        6.68
{txt}          1 {c |}{res}        433       93.32      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}        464      100.00
{txt}
{com}. qui log close
{smcl}
{com}{sf}{ul off}{smcl}
{com}{sf}{ul off}{txt}
{com}. * Footnote 16: 
. * Notably, we did not find any evidence for this after examining time patterns in total per capita expenditure for control households while leveraging 8 survey data points (month/years) from the baseline through to the last endline surveys (see Table A1). 
. tab time

       {txt}time {c |}      Freq.     Percent        Cum.
{hline 12}{c +}{hline 35}
2014_JanMar {c |}{res}      1,011       49.93       49.93
{txt}  2014 June {c |}{res}        133        6.57       56.49
{txt}  2014 Sept {c |}{res}        120        5.93       62.42
{txt}   2015 Jan {c |}{res}        133        6.57       68.99
{txt}   2015 Mar {c |}{res}        133        6.57       75.56
{txt}   2015 May {c |}{res}        121        5.98       81.53
{txt}  2015 June {c |}{res}        120        5.93       87.46
{txt}   2015 Oct {c |}{res}        133        6.57       94.02
{txt}   2016 Jan {c |}{res}        121        5.98      100.00
{txt}{hline 12}{c +}{hline 35}
      Total {c |}{res}      2,025      100.00
{txt}
{com}. xi: reg expp i.time
{txt}i.time{col 19}_Itime_0-8{col 39}(naturally coded; _Itime_0 omitted)

      Source {c |}       SS           df       MS      Number of obs   ={res}     1,844
{txt}{hline 13}{c +}{hline 34}   F(8, 1835)      = {res}     1.61
{txt}       Model {c |} {res} 2.3027e+09         8   287843483   {txt}Prob > F        ={res}    0.1161
{txt}    Residual {c |} {res} 3.2752e+11     1,835   178484126   {txt}R-squared       ={res}    0.0070
{txt}{hline 13}{c +}{hline 34}   Adj R-squared   ={res}    0.0027
{txt}       Total {c |} {res} 3.2982e+11     1,843   178958828   {txt}Root MSE        =   {res}  13360

{txt}{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 1} exppc_total{col 14}{c |} Coefficient{col 26}  Std. err.{col 38}      t{col 46}   P>|t|{col 54}     [95% con{col 67}f. interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 4}_Itime_1 {c |}{col 14}{res}{space 2}-1529.679{col 26}{space 2} 1334.135{col 37}{space 1}   -1.15{col 46}{space 3}0.252{col 54}{space 4}-4146.262{col 67}{space 3} 1086.905
{txt}{space 4}_Itime_2 {c |}{col 14}{res}{space 2} 2482.208{col 26}{space 2} 1379.312{col 37}{space 1}    1.80{col 46}{space 3}0.072{col 54}{space 4}-222.9794{col 67}{space 3} 5187.394
{txt}{space 4}_Itime_3 {c |}{col 14}{res}{space 2}-981.2825{col 26}{space 2} 1303.413{col 37}{space 1}   -0.75{col 46}{space 3}0.452{col 54}{space 4}-3537.612{col 67}{space 3} 1575.047
{txt}{space 4}_Itime_4 {c |}{col 14}{res}{space 2}-1529.679{col 26}{space 2} 1334.135{col 37}{space 1}   -1.15{col 46}{space 3}0.252{col 54}{space 4}-4146.262{col 67}{space 3} 1086.905
{txt}{space 4}_Itime_5 {c |}{col 14}{res}{space 2}-1224.857{col 26}{space 2} 1350.473{col 37}{space 1}   -0.91{col 46}{space 3}0.365{col 54}{space 4}-3873.483{col 67}{space 3}  1423.77
{txt}{space 4}_Itime_6 {c |}{col 14}{res}{space 2} 2482.208{col 26}{space 2} 1379.312{col 37}{space 1}    1.80{col 46}{space 3}0.072{col 54}{space 4}-222.9794{col 67}{space 3} 5187.394
{txt}{space 4}_Itime_7 {c |}{col 14}{res}{space 2}-981.2825{col 26}{space 2} 1303.413{col 37}{space 1}   -0.75{col 46}{space 3}0.452{col 54}{space 4}-3537.612{col 67}{space 3} 1575.047
{txt}{space 4}_Itime_8 {c |}{col 14}{res}{space 2}-1224.857{col 26}{space 2} 1350.473{col 37}{space 1}   -0.91{col 46}{space 3}0.365{col 54}{space 4}-3873.483{col 67}{space 3}  1423.77
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 13828.55{col 26}{space 2} 431.6354{col 37}{space 1}   32.04{col 46}{space 3}0.000{col 54}{space 4} 12982.01{col 67}{space 3}  14675.1
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}{txt}
{com}. qui log close
{smcl}
{com}{sf}{ul off}{smcl}
{com}{sf}{ul off}{txt}
{com}. * Sec 5.2 "At endline, women were asked whether they intended to look for a job in the subsequent 6 months, 
. * and about 30 percent of women, regardless of treatment status, expressed this intension"
. * In the next 6 months, do you intend to look for a job or start your own business (any type of income/production business)?
. tabstat w123w_willlookjob_6m , by(treatment)

{txt}Summary for variables: w123w_willlookjob_6m
Group variable: treatment (1 if treatment)

{ralign 9:treatment} {...}
{c |}      Mean
{hline 10}{c +}{hline 10}
{ralign 9:0} {...}
{c |}{...}
 {res} .2892593
{txt}{ralign 9:1} {...}
{c |}{...}
 {res} .3141176
{txt}{hline 10}{c +}{hline 10}
{ralign 9:Total} {...}
{c |}{...}
 {res} .3013333
{txt}{hline 10}{c BT}{hline 10}

{com}. qui log close
{smcl}
{com}{sf}{ul off}